Forum menu
Google Docs Spreads...
 

Google Docs Spreadsheet formatting.

Posts: 0
Free Member
Topic starter
 

I'm no expert on spreadsheets, but in Excel I can format a cell B1 to be blue if cell A1 "is not empty". I can't seem to do this using conditional formatting in google docs, I cant import the spreadsheet as it wipes some of the formatting and I am stuck. Help me?


 
Posted : 02/09/2022 4:37 pm
Posts: 15555
Full Member
 

No help whatsoever but excel does seem to be more feature rich for this kinda thing.

Do you have a Hotmail /outlook webmail account?
You can open spreadsheets in that like a kind of excel 'lite'?


 
Posted : 02/09/2022 4:45 pm
Posts: 78341
Full Member
 

https://support.google.com/docs/answer/78413

Any particular reason that the answer isn't "use Excel, then"?


 
Posted : 02/09/2022 5:28 pm
Posts: 0
Free Member
Topic starter
 

There is, the collaboration that I have been hoiked into agaisnt my will are using google docs and it ain't my rodeo.


 
Posted : 02/09/2022 7:04 pm
Posts: 20
Full Member
 

You need a a custom formula, bottom option

=A1=""


 
Posted : 02/09/2022 8:41 pm
Posts: 14286
Free Member
 

I can’t seem to do this using conditional formatting in google docs

You definitely can in sheets.


 
Posted : 03/09/2022 2:04 am