Highlite the cell if above 5:31

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello from Steved

Is it possble to highlite the cel in Col A with the color yellow if it is
above 5:31 please

Thankyou.
 
Is it possble to highlite the cel in Col A with the color
yellow if it is above 5:31 please
Click to expand...

Select your range or the entire column and click

Format / Conditional Formatting...

on Excel's menu. On the dialog box that appears, set the first drop-down
field to "Cell Value Is", set the second drop-down field to "greater than"
and type 5:31 in the third field. Now click the Format button and select the
highlight color you want from the Patterns tab and OK your way back to the
spreadsheet. That is it.. any cell having a time greater than 5:31 will be
shaded in the color you selected.

Rick
 
Thankyou Rick

Rick Rothstein (MVP - VB) said:
Select your range or the entire column and click

Format / Conditional Formatting...

on Excel's menu. On the dialog box that appears, set the first drop-down
field to "Cell Value Is", set the second drop-down field to "greater than"
and type 5:31 in the third field. Now click the Format button and select the
highlight color you want from the Patterns tab and OK your way back to the
spreadsheet. That is it.. any cell having a time greater than 5:31 will be
shaded in the color you selected.

Rick
Click to expand...
 
Back
Top