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 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago