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?
0
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
0
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:


0

Similar discussions

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

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

26 responses
What shall i do after formatting my laptop?
upen91 -
jack4rall -

1 response
Formula for conditional format to color cells
kipp2019 -
TrowaD -

14 responses
Conditional Formatting: 3 range of numbers
LCC -
LCC -

2 responses