View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TexJen TexJen is offline
external usenet poster
 
Posts: 10
Default If #, then Highlight

I'm needing to highlight the cells over a certain # in a column.
Hinky part is: these #s will change as the data changes.

Column H = Items Sold
I'm needing the worksheet to highlight the cells in that column 500.

The Items Sold change daily.
Just now sure how to go about this.

Appreciate any help.
Thank you!
-TexJen