Question description:
This user has given permission to use the problem statement for this
blog.
Conditional formatting - I'm trying to change the format of a cell based on the value in another cell. I have a table with 100+ lines; when column E reads "complete," I want column C to go back to plain format
Solved by Z. Y. in 7 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
22/05/2018 - 09:27
Hi, Thank you for using Got It Pro.
I’m happy to be able to help you today.
User
22/05/2018 - 09:27
I need excel help please
Excelchat Expert
22/05/2018 - 09:27
Sure
Excelchat Expert
22/05/2018 - 09:27
Would you like to share the file?
User
22/05/2018 - 09:28
No, I can't do that; simple questions I think - Conditional formatting of a large table; when column E reads "complete" I want column C to be formatted in a specfic way
User
22/05/2018 - 09:28
There's a formula but I can't figure it out
Excelchat Expert
22/05/2018 - 09:29
Ok highlight column C
Excelchat Expert
22/05/2018 - 09:29
But I need to know where the first cell of data is
Excelchat Expert
22/05/2018 - 09:29
let me give you an example
User
22/05/2018 - 09:30
I'm following so far
Excelchat Expert
22/05/2018 - 09:30
first select the data from C2 to C9
Excelchat Expert
22/05/2018 - 09:30
just like that where the first cell selected is C2 for example
Excelchat Expert
22/05/2018 - 09:30
then click on conditional formatting then new rule
Excelchat Expert
22/05/2018 - 09:31
select the last option, where you use a formula to formate
Excelchat Expert
22/05/2018 - 09:31
format*
Excelchat Expert
22/05/2018 - 09:31
in the formula bar enter =$E2="Complete" then click format
User
22/05/2018 - 09:31
yes
Excelchat Expert
22/05/2018 - 09:31
I used $E2 because the first cell selected in the highlighted range in is row 2
User
22/05/2018 - 09:32
ha!!! that worked!!
User
22/05/2018 - 09:32
You're the man/woman
Excelchat Expert
22/05/2018 - 09:32
great :)
Excelchat Expert
22/05/2018 - 09:33
Is there anything else I can help you with regarding this matter?
Excelchat Expert
22/05/2018 - 09:33
When you are done with the session please click on end session.
Have a great day ahead :)
User
22/05/2018 - 09:34
No, but many thanks!
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.