Previous Topic Next Topic

Conditional Formatting

Closed
BWitham5 Posts 3 Registration date Thursday March 22, 2018 Status Member Last seen April 6, 2018 - Apr 5, 2018 at 04:24 PM
 Blocked Profile - Apr 6, 2018 at 06:47 PM
I have cell G8 in excel which is a time stamp. I want it to be highlighted when it is greater than cell A8 which is a scheduled time.

2 responses

Answer 1 / 2
Blocked Profile
Apr 5, 2018 at 04:52 PM
Ok, what part are stuck with, the formula or the coloring?
BWitham5 Posts 3 Registration date Thursday March 22, 2018 Status Member Last seen April 6, 2018
Apr 6, 2018 at 12:55 PM
The formula
Answer 2 / 2
Blocked Profile
Apr 6, 2018 at 06:47 PM
In the formula bar of the rule, place the following: 

=G8>A8


Here is an example:


Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
If cell A1 has text then cell B2 has today's Date
Sasha -
ac3mark -

1 response