Excel VBA - 3 numbers,greater,smaller or equal logic
Hi,
Any body can help please.
Need an excel button coding , on click of which first 3 inputbox will ask three different numbers from user and will put these numbers in A2,B2 and C2 respectively then in cell D2 will put the greatest no ,E2 - smallest no and F2 will put Yes if they all are equal else no if they are not equal.
Also will change the font/Colour of greatest no to RED/BOLD and smallest number to GREEN/BOLD.(in cell A2,B2 or C2),
If button clicked again will put the next series in A3,B3 and C3 and so on(should not override previous filled cells.)
Have attached excel sheet with an example for reference.
Quick responses much appriciated, thank you.
Jhon.
Attachment | Size |
---|---|
logic.xlsx | 9.69 KB |
Recent comments
5 years 42 weeks ago
6 years 28 weeks ago
6 years 40 weeks ago
6 years 42 weeks ago
6 years 43 weeks ago
6 years 49 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago