Thread
:
Conditional formatting based on adjacent cell?
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
Conditional formatting based on adjacent cell?
for col a, formula is
=b2=???
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Custard Tart" wrote in message
...
I have a spreadsheet which needs a basic RAG format based on the cell
adjacent.
For example column L contains the score, column M contains the empty
box to be filled with colour based on the RAG status.
It should be formatted as follows:
Less than 18 = Green
18 = Amber
27 = Red
I'm not sure how to link it to the adjacent cell?
Thanks!
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett