Hi all is it possible for this to automatically highlight the cells in colour codes........
If Sign Rate =
80% or more then to be Green
60%-80% to be Orange
Below 60% to be Red
Hi all is it possible for this to automatically highlight the cells in colour codes........
If Sign Rate =
80% or more then to be Green
60%-80% to be Orange
Below 60% to be Red
Select I4:I14 and then in Conditional Formatting use the following rules:
Condition 1: Cell Value Is...Less Than...0.6 and format Red
Condition 2: Cell Value Is...Less Than...0.8 and format Amber
Condition 3: Cell Value is...Greater Than Or Equal To...0.8 and format Green
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks