Previous Topic Next Topic

Conditional formatting

Closed
dhoot Posts 1 Registration date Saturday 12 October 2013 Status Member Last seen 12 October 2013 - 12 Oct 2013 à 06:49
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 12 Oct 2013 à 07:27
I want to do conditional formation in that i have two columns where A (Due Date) & In B ( Remark) if my validation due date is pass then i want to highlighted it by red color till whenever we do remark as OK if we enter OK in column B then Highlighted the column A with green color

1 response

Réponse 1 / 1
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
12 Oct 2013 à 07:27
use these formulas in conditiona formatting

suppose row 1 is having heading
sselect A2

unde conditional foramttsing the two conditiona apply

=if(and(a2>=today(),B2<>"ok") format this as red
second rule
=if(and(a2>=today(),B2="ok") now format as gsrsese

now selesct A2 edit copy
select A3 down edit lpastespecial-formats

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
Conditional Format Cells Based on Another Cell and Own Cell
Elaine -
x -

1 response
Conditional formatting based text in another cell
y88y -
y88y -

2 responses
Conditional formatting several cells risk register
oyvinols -
fdibbins -

1 response