Thread: Conditional Format based on a different cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
klswvu[_2_] klswvu[_2_] is offline
external usenet poster
  
Posts: 27
Default Conditional Format based on a different cell
In Cell a3... Format Conditional Formatting
Condition 1 change drop down from "Cell Value Is" to "Formula Is"
Enter the formula... =A1="Yes"
Click the Format button and set the format.



"Ramos" wrote:

Hello, I'm trying to have cell a3 highlight when I enter a value if value in
cell a1 = yes. PLEASE HELP!

Reply With QuoteReply With Quote