Conditional formatting

Patriot2879

Well-known Member
Joined
Feb 1, 2018
Messages
1,004
Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to be filled with the colour Green, can you help me please?
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
4,187
ifcf.png

O4: =IF(P4=1,"Fully Utilised","") and drag down
CF - select range O4:O54 then
cf.png
 

Patriot2879

Well-known Member
Joined
Feb 1, 2018
Messages
1,004
Hi thank you for that the only probably i got in column O to last row is that i have a 'list' in the cells will this still work
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
4,187
all in range O4:O54 will be replaced by formula
you cannot eat cake and have cake
 

Patriot2879

Well-known Member
Joined
Feb 1, 2018
Messages
1,004
Hi i get an error when inputting the =IF(P4=1,"Fully Utilised","") in cell O4 i think this is because i have a 'list' selection in the cell
 

Patriot2879

Well-known Member
Joined
Feb 1, 2018
Messages
1,004
I have done it in Conditional formatting before but cant remember how i did it
 

Patriot2879

Well-known Member
Joined
Feb 1, 2018
Messages
1,004
HI i just remembered i used this code below how can i still use this code and amend it to add the above query?
VBA Code:
Private Sub worksheet_calculate()
Application.EnableEvents = False
Dim rw As Long
For rw = 4 To 54
If (Cells(rw, "M").Value >= 6 Or Cells(rw, "N").Value >= 6) And Cells(rw, "O").Value <> "Fully Utilised" Then Cells(rw, "O").Value = "Fully Utilised"
Next rw
Application.EnableEvents = True
End Sub
 

Forum statistics

Threads
1,085,149
Messages
5,381,992
Members
401,764
Latest member
pzippel

Some videos you may like

This Week's Hot Topics

Top